CSC 240 Data Processing and Database Systems Fall 2007

Project Work Distribution Worksheet

Initials: _______ _______ _______

Please Mark the responsibilities of Each Team Member by placing a check or other mark below:

(if your design does not exactly match, feel free to use “other” spaces and/or replace my terminology

with yours)

DESIGN

Provided Leadership for DB Design _______ _______ _______

Provided Insight for DB Design _______ _______ _______

Provided Input for DB Design _______ _______ _______

REGULAR NEW DATA INPUT

Developed Form for New Driver data entry _______ _______ _______

Integrated New Driver data entry into application _______ _______ _______

Developed Form for New Vehicle data entry _______ _______ _______

Integrated New Vehicle Keyword data entry into application _______ _______ _______

Developed Form for New Ownership (Driver-Vehicle bridge) data entry _______ _______ _______

Integrated New Ownership (Driver-Vehicle bridge) data entry into application _______ _______ _______

Developed Form for New EZ Pass Account data entry _______ _______ _______

Integrated New EZ Pass Account data entry into application _______ _______ _______

Developed Form for New EZ Pass Device data entry _______ _______ _______

Integrated New EZ Pass Device data entry into application _______ _______ _______

Developed Form for New Customer data entry _______ _______ _______

Integrated New Customer data entry into application _______ _______ _______

Developed Form for New Customer View data entry _______ _______ _______

Integrated New Customer View data entry into application _______ _______ _______

Developed Form for New Critic Rating data entry _______ _______ _______

Integrated New Critic Rating data entry into application _______ _______ _______

Developed Form for New Similar Movie data entry _______ _______ _______

Integrated New Similar Movie data entry into application _______ _______ _______

INITIAL (THEN INFREQUENT) NEW DATA INPUT

Developed Form for New Offense data entry _______ _______ _______

Integrated New Offense data entry into application _______ _______ _______

Developed Form for New Police Officer data entry _______ _______ _______

Integrated New Police Officer data entry into application _______ _______ _______

Developed Form for New Toll Plaza data entry _______ _______ _______

Integrated New Toll Plaza data entry into application _______ _______ _______

Developed Form for other new data entry (specify) _______ _______ _______

Integrated other new data entry into application _______ _______ _______

UPDATES / ERROR CORRECTION

Developed Update Driver Info approach _______ _______ _______

Integrated Update Driver Info approach into application _______ _______ _______

Developed Update Vehicle Info approach _______ _______ _______

Integrated Update Vehicle Info approach into application _______ _______ _______

Developed Update Ownership Info approach _______ _______ _______

Integrated Update Ownership Info approach into application _______ _______ _______

Developed Update OTHER Info approach (specify) _______ _______ _______

Integrated Update OTHER Info approach into application _______ _______ _______

DAILY OPERATIONS

Developed Toll Charged approach _______ _______ _______

Integrated Toll Charged approach into application _______ _______ _______

Developed Payment Received approach _______ _______ _______

Integrated Payment Received approach into application _______ _______ _______

Developed Ticket Issued approach _______ _______ _______

Integrated Ticket Issued approach into application _______ _______ _______

Developed Other Daily Operations (specify) _______ _______ _______

Integrated Other Daily Operations into application _______ _______ _______

QUERIES / REPORTS

Developed Query 1 _______ _______ _______

Developed Report to Give Nice Display of Query 1 Results (Optional) _______ _______ _______

Integrated Query 1 into Application _______ _______ _______

Developed Query 2 _______ _______ _______

Developed Report to Give Nice Display of Query 2 Results (Optional) _______ _______ _______

Integrated Query 2 into Application _______ _______ _______

Developed Query 3 _______ _______ _______

Developed Report to Give Nice Display of Query 3 Results (Optional) _______ _______ _______

Integrated Query 3 into Application _______ _______ _______

Developed Query 4 _______ _______ _______

Developed Report to Give Nice Display of Query 4 Results (Optional) _______ _______ _______

Integrated Query 4 into Application _______ _______ _______

Developed Query 5 _______ _______ _______

Developed Report to Give Nice Display of Query 5 Results (Optional) _______ _______ _______

Integrated Query 5 into Application _______ _______ _______

Developed Query 6 _______ _______ _______

Parameterized Query 6 _______ _______ _______

Developed Report to Give Nice Display of Query 6 Results (Optional) _______ _______ _______

Integrated Query 6 into Application _______ _______ _______

Developed Query 7 _______ _______ _______

Parameterized Query 7 _______ _______ _______

Developed Report to Give Nice Display of Query 7 Results (Optional) _______ _______ _______

Integrated Query 7 into Application _______ _______ _______

Developed Query 8 _______ _______ _______

Parameterized Query 8 _______ _______ _______

Developed Report to Give Nice Display of Query 8 Results (Optional) _______ _______ _______

Integrated Query 8 into Application _______ _______ _______

Developed Query 9 _______ _______ _______

Parameterized Query 9 _______ _______ _______

Developed Report to Give Nice Display of Query 9 Results (Optional) _______ _______ _______

Integrated Query 9 into Application _______ _______ _______

Developed Query 10 _______ _______ _______

Parameterized Query 10 _______ _______ _______

Developed Report to Give Nice Display of Query 10 Results (Optional) _______ _______ _______

Integrated Query 10 into Application _______ _______ _______

Developed Query 11 _______ _______ _______

Developed Report to Give Nice Display of Query 11 Results (Optional) _______ _______ _______

Integrated Query 11 into Application _______ _______ _______

Developed Query 12 _______ _______ _______

Developed Report to Give Nice Display of Query 12 Results (Optional) _______ _______ _______

Integrated Query 12 into Application _______ _______ _______

Developed Query 13 _______ _______ _______

Parameterized Query 13 _______ _______ _______

Developed Report to Give Nice Display of Query 13 Results (Optional) _______ _______ _______

Integrated Query 13 into Application _______ _______ _______

Developed Query 14 _______ _______ _______

Developed Report to Give Nice Display of Query 14 Results (Optional) _______ _______ _______

Integrated Query 14 into Application _______ _______ _______

Developed Query 15 _______ _______ _______

Developed Report to Give Nice Display of Query 15 Results (Optional) _______ _______ _______

Integrated Query 15 into Application _______ _______ _______

Developed Query 16 _______ _______ _______

Parameterized Query 16 _______ _______ _______

Developed Report to Give Nice Display of Query 16 Results (Optional) _______ _______ _______

Integrated Query 16 into Application _______ _______ _______

Developed Query 17 _______ _______ _______

Parameterized Query 17 _______ _______ _______

Developed Report to Give Nice Display of Query 17 Results (Optional) _______ _______ _______

Integrated Query 17 into Application _______ _______ _______

Developed Query 18 _______ _______ _______

Parameterized Query 18 _______ _______ _______

Developed Report to Give Nice Display of Query 18 Results (Optional) _______ _______ _______

Integrated Query 18 into Application _______ _______ _______

Developed Query 19 _______ _______ _______

Developed Report to Give Nice Display of Query 19 Results (Optional) _______ _______ _______

Integrated Query 19 into Application _______ _______ _______

Developed Query 20 _______ _______ _______

Parameterized Query 20 _______ _______ _______

Developed Report to Give Nice Display of Query 20 Results (Optional) _______ _______ _______

Integrated Query 20 into Application _______ _______ _______

Developed Query 21 _______ _______ _______

Developed Report to Give Nice Display of Query 21 Results (Optional) _______ _______ _______

Integrated Query 21 into Application _______ _______ _______

OTHER (EXTRA) QUERIES/REPORTS (specify)

MENUS (Organization of the Application May Vary)

Developed Main Menu _______ _______ _______

Integrated Main Menu into Application _______ _______ _______

OTHER MENUS (specify)

Developed Menu _______ _______ _______

Integrated Menu into Application _______ _______ _______

NAVIGATION

Developed AutoExec Macro (Optional) _______ _______ _______

OTHER (specify) _______ _______ _______

SAMPLE DATA

Developed Sample Data for Drivers _______ _______ _______

Entered Sample Data for Drivers _______ _______ _______

Developed Sample Data for Critic Vehicles _______ _______ _______

Entered Sample Data for Critic Vehicles _______ _______ _______

Developed Sample Data for Ownership _______ _______ _______

Entered Sample Data for Ownership _______ _______ _______

Developed Sample Data for Offense _______ _______ _______

Entered Sample Data for Offense _______ _______ _______

Developed Sample Data for Police Officers _______ _______ _______

Entered Sample Data for Police Officers _______ _______ _______

Developed Sample Data for EZ Pass Accounts _______ _______ _______

Entered Sample Data for EZ Pass Accounts _______ _______ _______

Developed Sample Data for EZ Pass Devices _______ _______ _______

Entered Sample Data for EZ Pass Devices _______ _______ _______

Developed Sample Data for Toll Plazas _______ _______ _______

Entered Sample Data for Toll Plazas _______ _______ _______

Developed Sample Data for Tickets _______ _______ _______

Entered Sample Data for Tickets _______ _______ _______

Developed Sample Data for Tolls Charged _______ _______ _______

Entered Sample Data for Tolls Charged _______ _______ _______

Developed Sample Data for Payments _______ _______ _______

Entered Sample Data for Payments _______ _______ _______

Developed Sample Data for other (specify …) _______ _______ _______

Entered Sample Data for other (specify …) _______ _______ _______

Developed Sample Data for other (specify …) _______ _______ _______

Entered Sample Data for other (specify …) _______ _______ _______

PROJECT MANAGEMENT ETC

Provided Informal Leadership for Project Development _______ _______ _______

Provided Informal Project Management for Project Development _______ _______ _______

Provided system test effort _______ _______ _______

DOCUMENTATION

Documented Functional Dependencies _______ _______ _______

Documented Entity-Relationships _______ _______ _______

Documented how to use application _______ _______ _______

Documented tables, forms, reports, menus, macros, queries, reports, data via printouts _______ _______ _______

OTHER

(list ...) _______ _______ _______